/* Dwarf_Load.sql */

insert into mountains (name,location)
	values ('Moria','Misty Mountains');

insert into mountains (name,location)
	values ('Erebor','Rhovanion');

insert into mountains (name,location)
	values ('Iron Hills','Rhovanion');

insert into dwarves (name,born)
	values ('Durin',1731);

insert into dwarves (name,born)
	values ('Nain',1832);

insert into dwarves (name,born)
	values ('Thrain',1934);

insert into dwarves (name,born)
	values ('Thorin',2035);

update mountains set king_id = 
	(select id from dwarves where name = 'Durin')
	where name = 'Moria';

update dwarves set mountain_id =
	(select id from mountains where name = 'Moria')
	where mountain_id is null;

insert into dwarves (name,born)
	values ('Gloin',2136);

insert into dwarves (name,born)
	values ('Oin',2238);

insert into dwarves (name,born)
	values ('Dain',2440);

insert into dwarves (name,born)
	values ('DainWife',2450);

update mountains set king_id = 
	(select id from dwarves where name = 'Dain')
	where name = 'Erebor';

update dwarves set mountain_id =
	(select id from mountains where name = 'Erebor')
	where mountain_id is null;

update dwarves set spouse_id = 
	(select id from dwarves where name = 'Dain')
	where name = 'DainWife';

update dwarves set spouse_id = 
	(select id from dwarves where name = 'DainWife')
	where name = 'Dain';

insert into visits (dwarf_id,mountain_id)
	select id, mountain_id from dwarves;

insert into visits (dwarf_id, mountain_id)
	values (1,2);
insert into visits (dwarf_id, mountain_id)
	values (1,3);
insert into visits (dwarf_id, mountain_id)
	values (3,3);
insert into visits (dwarf_id, mountain_id)
	values (5,3);